
EXEC [dbo].[AddGame] @Name = 'Game 1',@PlayerCount = 2

EXEC [dbo].[AddPlayer] @Name = 'Bank',@Type = 'Bank'
EXEC [dbo].[AddPlayer] @Name = 'Car',@Type =  'R'
EXEC [dbo].[AddPlayer] @Name = 'Mobile',@Type =  'R'
EXEC [dbo].[AddPlayer] @Name = 'Laptop',@Type =  'R'
EXEC [dbo].[AddPlayer] @Name = 'Shoe',@Type =  'R'

EXEC [dbo].[AddPlayerEnrollment] @Game_ID=1,@Player_ID = 1, @Player_Dice = NULL, @SequenceNo=0, @IsMyMove='N'
EXEC [dbo].[AddPlayerEnrollment] @Game_ID=1,@Player_ID = 2, @Player_Dice = 'Dice1', @SequenceNo=10, @IsMyMove='N'
EXEC [dbo].[AddPlayerEnrollment] @Game_ID=1,@Player_ID = 3, @Player_Dice = 'Dice2', @SequenceNo=20, @IsMyMove='N'
EXEC [dbo].[AddPlayerEnrollment] @Game_ID=1,@Player_ID = 4, @Player_Dice = 'Dice3', @SequenceNo=30, @IsMyMove='N'
EXEC [dbo].[AddPlayerEnrollment] @Game_ID=1,@Player_ID = 5, @Player_Dice = 'Dice4', @SequenceNo=40, @IsMyMove='N'

EXEC [dbo].[InitializeLand] 
EXEC [dbo].[InitializeDeed] @Loop_Limit = 40

EXEC [dbo].[InitializeBankAsset] @Game_ID = 1

EXEC [dbo].[InitializeGameCard] @Loop_Limit_Chance = 15,@Loop_Limit_CommunityChest = 15

EXEC [dbo].[InitializePlayerAsset] @Game_ID = 1


EXEC [dbo].[PopulateDeedSettings]

delete from [dbo].[GameAction]

INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T','Bank','Purchase')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T','Bank','Auction')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('L','Bank','Auction')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('L','Bank','Auction')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('U','Bank','Auction')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('U','Bank','Auction')

INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T','R','PayRent')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T','R','Bankrupt')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('L','R','PayRent')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('L','R','Bankrupt')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('U','R','PayRent')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('U','R','Bankrupt')

INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T1','Bank','Tax')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('T2','Bank','Tax')

INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('S','Bank','Salary')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('GJ','Bank','GotoJail')

INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('CH','Bank','FollowOrder')
INSERT INTO [dbo].[GameAction]([LandType],[LandOwnerType],[GameActionKey]) VALUES('CC','Bank','FollowOrder')
